USE [Training]
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'dbo.Position_SkillSet') AND type in (N'U'))
CREATE TABLE [dbo].[Position_SkillSet](
	[SkillSetID] [int] NOT NULL,
	[PositionID] [int] NOT NULL
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Position_SkillSet]  WITH CHECK ADD  CONSTRAINT [FK_Position_SkillSet_Position] FOREIGN KEY([PositionID])
REFERENCES [dbo].[Position] ([PositionID])
GO

ALTER TABLE [dbo].[Position_SkillSet] CHECK CONSTRAINT [FK_Position_SkillSet_Position]
GO

ALTER TABLE [dbo].[Position_SkillSet]  WITH CHECK ADD  CONSTRAINT [FK_Position_SkillSet_SkillSet] FOREIGN KEY([SkillSetID])
REFERENCES [dbo].[SkillSet] ([SkillSetID])
GO

ALTER TABLE [dbo].[Position_SkillSet] CHECK CONSTRAINT [FK_Position_SkillSet_SkillSet]
GO

